﻿CREATE proc capmenu_resetgroup  
@MaNhom int  
as  
if exists (select * from QuanTri_CapQuyenNguoiDungSuDungMenu Where MaNhomUser=@MaNhom)  
begin  
delete from QuanTri_EditUserRoleInGroup Where IDCapQuyen in (select ID from QuanTri_CapQuyenNguoiDungSuDungMenu Where MaNhomUser=@MaNhom  )
delete from QuanTri_CapQuyenNguoiDungSuDungMenu Where MaNhomUser=@MaNhom  
select ErrCode=1  
end  
else  
begin  
select ErrCode=0  
end
